[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '7' >
8 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 13.4615 | 1998-07-19 | Marketing | kevin0@adventure-works.com | Kevin Brown | 150-555-0189 | 253022876 | Kevin | M | 2018-04-13 | Brown | adventure-works\kevin0 | S | F | 7 | 2 | 150-555-0189 | | 41 | 2018-04-13 | Current | Marketing Assistant | 42 |
| 48 | 14.4231 | 1998-08-06 | Marketing | sariya0@adventure-works.com | Sariya Harnpadoungsataya | 399-555-0176 | 95958330 | Sariya | M | 2020-02-28 | Harnpadoungsataya | adventure-works\sariya0 | S | E | 7 | 2 | 399-555-0176 | | 42 | 2020-02-28 | Current | Marketing Specialist | 45 |
| 273 | 13.4615 | 1986-06-02 | Marketing | wanida0@adventure-works.com | Wanida Benshoof | 708-555-0141 | 323403273 | Wanida | F | 2022-03-25 | Benshoof | adventure-works\wanida0 | M | M | 7 | 2 | 708-555-0141 | | 40 | 2022-03-25 | Current | Marketing Assistant | 41 |
| 275 | 14.4231 | 1989-05-22 | Marketing | john5@adventure-works.com | John Wood | 486-555-0150 | 222969461 | John | M | 2022-04-25 | Wood | adventure-works\john5 | S | L | 7 | 2 | 486-555-0150 | | 44 | 2022-04-25 | Current | Marketing Specialist | 48 |
| 276 | 13.4615 | 1989-04-16 | Marketing | mary2@adventure-works.com | Mary Dempsey | 124-555-0114 | 52541318 | Mary | F | 2022-05-02 | Dempsey | adventure-works\mary2 | S | A | 7 | 2 | 124-555-0114 | | 41 | 2022-05-02 | Current | Marketing Assistant | 43 |
| 109 | 14.4231 | 1973-11-29 | Marketing | mary0@adventure-works.com | Mary Gibson | 531-555-0183 | 767955365 | Mary | F | 2020-03-30 | Gibson | adventure-works\mary0 | M | E | 7 | 2 | 531-555-0183 | | 43 | 2020-03-30 | Current | Marketing Specialist | 46 |
| 207 | 14.4231 | 1997-04-22 | Marketing | terry0@adventure-works.com | Terry Eminhizer | 138-555-0118 | 243322160 | Terry | M | 2020-05-18 | Eminhizer | adventure-works\terry0 | M | J | 7 | 2 | 138-555-0118 | | 42 | 2020-05-18 | Current | Marketing Specialist | 44 |
| 122 | 14.4231 | 1990-09-03 | Marketing | jill0@adventure-works.com | Jill Williams | 510-555-0121 | 72636981 | Jill | F | 2020-04-05 | Williams | adventure-works\jill0 | M | A | 7 | 2 | 510-555-0121 | | 43 | 2020-04-05 | Current | Marketing Specialist | 47 |
Generated 2025-09-15 13:53:45.555 UTC